#ifndef EXECSQL_H
#define EXECSQL_H

#include "admininfo.h"
#include "studentinfo.h"
#include "teacherinfo.h"
#include"checkininfo.h"


class ExecSQL
{
public:
    ExecSQL();
    ~ExecSQL();

    static AdminInfo selectAdminInfo(QString id);
    static StudentInfo selectStudentInfo(QString id);
    static TeacherInfo selectTeacherInfo(QString id);
    static CheckinInfo selectCheckinInfo(QString classid);

    static AdminInfo insertAdminInfo(const QString &id,
                                     const QString &name ,const QString &sex,
                                                const QString &birth, const QString &pswd);
    static StudentInfo insertStudentInfo(const QString &id,const QString &name,
                                         const QString &xuehao,const QString &pswd,
                                         const QString &sex,const QString &classid,const QString &RxTime);
    static TeacherInfo insertTeacherInfo(const QString &id, const QString &teacherID,
                                         const QString &XID, const QString &Name,const QString
                                                  &Sex, const QString &Birth, const QString &pswd);
    static CheckinInfo insertCheckinInfo(const QString &XID,const QString &ScienceID,
                                         const QString &teacherId,const QString &Classid,
                                         const QString &RoomID,const QString &CheckinTime,
                                         const QString &xuehao);

};

#endif // EXECSQL_H
